﻿//AcademicPlanner - course registration planning web app.
//Copyright (C) 2009  Boubacar Diallo

//This program is free software; you can redistribute it and/or
//modify it under the terms of the GNU General Public License
//as published by the Free Software Foundation; either version 2
//of the License, or (at your option) any later version.

//This program is distributed in the hope that it will be useful,
//but WITHOUT ANY WARRANTY; without even the implied warranty of
//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//GNU General Public License for more details.

//You should have received a copy of the GNU General Public License
//along with this program; if not, write to the Free Software
//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AcademicPlanner.Data.Entities;
using NHibernate.Tool.hbm2ddl;
using NHibernate;

namespace AcademicPlanner.Data.Repositories
{
	/// <summary>
	/// AcademicScheduleEntityRepository serves as the repository for <c>AcademicScheduleEntity</c>s.
	/// </summary>
	/// <since>1.0</since>
	public class AcademicScheduleEntityRepository : EntityRepository<AcademicScheduleEntity>
    {
		internal override string DBTableName { get { return "academic_schedules"; } }

		/// <summary>
		/// Gets the prefix for named queries of <c>AcademicScheduleEntity</c>s.
		/// </summary>
		/// <since>1.0</since>
		protected override string NamedQueriesPrefix
		{
			get
			{
				return "AcademicScheduleEntity";
			}
		}


		class InstanceHolder
		{
			internal static AcademicScheduleEntityRepository INSTANCE = new AcademicScheduleEntityRepository();
		}


		/// <summary>
		/// Gets the single AcademicScheduleEntityRepository instance.
		/// </summary>
		/// <returns>The single instance of AcademicScheduleEntityRepository.</returns>
		/// <since>1.0</since>
		internal static AcademicScheduleEntityRepository GetInstance()
		{
			return InstanceHolder.INSTANCE;
		}

		internal IList<AcademicScheduleEntity> FindForAcademicPlanEntity(int pAcademicPlanEntityId)
		{
			IList<AcademicScheduleEntity> rEnts;

			try
			{
				var vQuery = GetNamedQuery("for.academicplanentity");
				rEnts = QueryForAcademicPlanEntity(vQuery, pAcademicPlanEntityId);
			}
			catch (HibernateException vHx)
			{
				var vDx = new DataException(DataErrorCode.QUERY_ACADEMICSCHEDULE_ENTITY_FOR_ACADEMICPLAN_ENTITY_FAILED, vHx);
				throw vDx;
			}

			return rEnts;
		}

		private IList<AcademicScheduleEntity> QueryForAcademicPlanEntity(IQuery pQuery, int pAcademicPlanEntityId)
		{
			pQuery.SetInt32("id", pAcademicPlanEntityId);
			return pQuery.List<AcademicScheduleEntity>();
		}
	}
}
